-- 支线_网点装车扫描件数
DROP TABLE jms_dm.dm_tms_sitesend_number_ht;
CREATE EXTERNAL TABLE jms_dm.dm_tms_sitesend_number_ht(
	shipment_no string COMMENT '任务编号',
	planned_departure_time string COMMENT '计划发车时间_ef',
    scan_site_code string COMMENT '扫描网点编号',
    next_station_code string COMMENT '下一站编号',
	scan_site string COMMENT '扫描网点',
	next_station string COMMENT '下一站',
	scan_site_number int COMMENT '网点装车扫描的件数',
	etl_time string COMMENT '入仓时间'
 )
COMMENT '支线_网点装车扫描件数'
PARTITIONED BY (dt string COMMENT '计划发车时间')
STORED AS PARQUET
LOCATION '/dw/hive/jms_dm.db/external/dm_tms_sitesend_number_ht'
TBLPROPERTIES (
          'discover.partitions' = 'false',
          'parquet.column.index.access' = 'true'
          );
